home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.bin / More Information / GQL V3.0 / Open ME! - USA Sales / Open ME! - USA Sales.rsrc / gDEM_23506_Top Sales < prev    next >
Text File  |  1992-01-27  |  235b  |  1 lines
  1. select staff.first_name, staff.last_name, offices.region, orders.ord_amount from staff, offices, orders where ((orders.ord_amount > $50000)) and staff.rep_office = offices.office_nr and staff.rep_nr = orders.salesrep order by 4 desc ;